Work Order Accrual Report and Export
OBJECTIVE
The Work Order Accrual Report and Export function is used to print a report of unbilled work orders and to generate an Excel file that will be used to post deferred income (accrued charges).
|
This report includes all of the items entered in the Work Orders module as well as transactions from other maestro* modules in which the work order was identified. |
PREREQUISITE
- Configuration - Work Order (accrued section)
- Enter Work Orders
Steps
|
maestro* > Projects > Work Orders > Processing > Work Order Accrual Report and Export |
Export accrued work orders
- Select one or more Projects.
The ... symbol is used to select more advanced search criteria.
The + symbol is used to drill down further to expand the information that can be selected.
Field
Description
Detail level
Report Detail Level.
Available values.
Project Template
Used to select a project template to build the columns of the report.
NOTE: A column will be created for each activity in the project template.
If the activity on the work order matches an activity in the project template, the amount will be displayed below the column for the existing activity. If the activity for the transaction does not exist in the project template, the amount of the transaction will be displayed in the Other Act column.
Group Projects by Category
Used to group information based on the project category.
As of Date
Selects the date on which the report is requested.
NOTE: Transactions dated after the date entered in this field are not printed on the report.
Cost / Selling Price
Determines the price displayed on the report.
- Click Accept.
The accrued work orders report is displayed in the report viewer.
- Click Close to exit the viewer and display the "Do you want to export the accrued entry to Excel?" message. Click Yes to export the accrued charges entry to Excel.
The accrued charges activities will be determined based on the values entered in work order configuration in the accrued section. For the "credit" portion, if an activity is not specified, the system uses the activity specified in the original transaction on the Work Order.
The accrued charges groups will be determined based on the values entered in Configuration for work orders in the accrued section, as well as in Define Cost Groups.
See also